Do you have a solid Transact-SQL foundation? This query language, also known as T-SQL, is used to work with data in SQL Server and Azure SQL Database, and is a fundamental skill for aspiring database professionals and application developers.

Explore T-SQL in a series of self-paced modules which include lectures, demos, hands-on labs, and self-assessments. Find out how to use T-SQL to retrieve, insert, update, and delete data in a database. Learn about table expressions, grouping sets, error handling, and more. If you're studying for Exam 70-461, this course can help you prepare for it.

(NOTE: Download course lab files.)

Instructors | Graeme Malcolm - Microsoft Senior Content Developer, Geoff Allix - Content Master Principal Technologist
Course Introduction

Learn about the goals of the course and how to set up an Azure SQL Database environment for the labs that you will complete during subsequent modules.
Introduction to Transact-SQL

Find out how to set up a sample database in Microsoft Azure SQL Database to use in the supplementary labs for this course. Then, learn how to use the SELECT statement in Transact-SQL to create basic queries that return data from tables in a database.
Querying Tables with SELECT

Build on the basic SELECT syntax discussed in the previous module to learn how to sort and filter query results with the ORDER BY and WHERE clauses.  
Querying Multiple Tables with Joins

Explore the concept of joins in relational database queries, and then hear how to implement inner, outer, cross, and self joins by using the JOIN clause. 
Using Set Operators

Learn how to combine sets of data returned by queries by using the UNION operator.
Using Functions and Aggregating Data

Get to know commonly used built-in functions, and find out how to use them. Learn to use aggregate functions to summarize data, and work with the GROUP BY clause to retrieve grouped aggregations.
Using Subqueries and APPLY

Get the details on including subqueries within a query, and see how to work with correlated subqueries and the APPLY operator to use the results from one query in another.   
Using Table Expressions

Learn various techniques that can be used to create tabular structures in Transact-SQL, including views, temporary tables, table variables, table-valued functions, and common table expressions (CTEs).
Grouping Sets and Pivoting Data

Find out how to use the GROUPING SET subclause of the GROUP BY clause to specify multiple groupings in a single query. Then, see how to use the PIVOT and UNPIVOT operators to switch the orientation of data between column-oriented and row-oriented.
Modifying Data

Get the details on modifying data in tables by using the INSERT, UPDATE, and DELETE statements.
Programming with Transact-SQL

Learn to create Transact-SQL scripts that include programmatic constructs, such as conditional logic and loops.  
Error Handling and Transactions

Find out how to create Transact-SQL code that includes error handling. Learn about the concept of a transaction and how to implement explicit transactions in Transact-SQL code.   
Recommended Resources & Next Steps

Take this opportunity to learn more about Transact-SQL, at your own pace.
Learn

    00 | Course Introduction
    01 | Introduction to Transact-SQL
    02 | Querying Tables with SELECT
    03 | Querying Multiple Tables with Joins
    04 | Using Set Operators
    05 | Using Functions and Aggregating Data
    06 | Using Subqueries and APPLY
    07 | Using Table Expressions
    08 | Grouping Sets and Pivoting Data
    09 | Modifying Data
    10 | Programming with Transact-SQL
    11 | Error Handling and Transactions
    Recommended Resources & Next Steps

Prerequisites
None


Time requirements, modules, assessments and points for this course:
7 hours* 13 modules 11 assessment
*Excluding labs, knowledge checks and assessments